from django.contrib.auth.models import AbstractUser
from django.db import models

# Create your models here.
from oauths.utils import BaseModel


class User(AbstractUser):
    # 声明字段(内置有这些字段)
    # id =models.IntegerField(unique=True, primary_key=True)
    # username = models.CharField(max_length=240, null=False)
    # password = models.
    mobile = models.CharField(max_length=11, unique=True, verbose_name="手机号")
    email = models.EmailField(max_length=20, verbose_name="邮件")
    is_checked = models.BooleanField(default=False, verbose_name="邮箱验证码激活状态")

# 常用密码设置方法
# set_password
# check_passwrod
    class Meta:
        db_table = "tb_users"
        verbose_name = "用户"
        verbose_name_plural = verbose_name


class Address(BaseModel):
    """
    用户的收货地址
    """
    # 关联等级：CASCADE　表示主键被删除了，则外键对应的数据也被删除，级联删除
    user = models.ForeignKey(User, on_delete=models.CASCADE, related_name='addresses', verbose_name='用户')
    title = models.CharField(max_length=20, verbose_name='地址名称')
    receiver = models.CharField(max_length=20, verbose_name='收货人')
    # 关联等级：PROTECT 表示主键删除的时候，必须外键先被删除，保护
    province = models.ForeignKey('areas.Area', on_delete=models.PROTECT, related_name='province_addresses', verbose_name='省')
    city = models.ForeignKey('areas.Area', on_delete=models.PROTECT, related_name='city_addresses', verbose_name='市')
    district = models.ForeignKey('areas.Area', on_delete=models.PROTECT, related_name='district_addresses', verbose_name='区')
    place = models.CharField(max_length=50, verbose_name='地址')
    mobile = models.CharField(max_length=11, verbose_name='手机')
    tel = models.CharField(max_length=20, null=True, blank=True, default='', verbose_name='固定电话')
    email = models.CharField(max_length=30, null=True, blank=True, default='', verbose_name='电子邮箱')
    is_deleted = models.BooleanField(default=False, verbose_name='逻辑删除')

    class Meta:
        db_table = 'tb_address'
        verbose_name = '用户地址'
        verbose_name_plural = verbose_name
        # 设置数据查询时的排序字段以及排序方式[ - 表示倒序，从大到小 ]
        ordering = ['-update_time']